package util;

public class SpatialQueries {
	
	public static String GEOM_TAG = "<GEOM_TAG>";
	
	public static String INSERT_ROTA = "INSERT INTO \"GEOPIPA\".\"ROTA_CAMINHAO\" (\"COD_ROTA\", \"COD_CAMINHAO\", " +
			"\"DATA_ROTA\", \"GEOMETRIA\") " +
	" VALUES (1, '2011-06-08', ST_GEOMFROMTEXT(ST_ASTEXT(ST_GEOMFROMKML('"+ GEOM_TAG + "')), 4618));";
	
	
	public static String BUSCA_CAMINHOES = "SELECT \"COD_CAMINHAO\" FROM \"GEOPIPA\".\"CAMINHAO\";";

}
